Assumption: 1 kBtu=3.412 KWH
Assumption: 1 kBtu=100.00039 THM
List the electricity and gas consumption of each month from the first quarter of 2017 to the second quarter of 2021 in chronological order.
Take kBtu as the unit for statistics.
## YEAR MONTH Time TOTALTHM Residential_Gas_kBtu TOTALKWH
## 1 2017 1 2017-01-01 332986863 33298816165 2696632298
## 2 2017 2 2017-02-01 214756795 21475763255 2089405296
## 3 2017 3 2017-03-01 167698331 16769898502 2007875145
## 4 2017 4 2017-04-01 128910844 12891134675 1838107707
## 5 2017 5 2017-05-01 93587412 9358777699 2070656073
## 6 2017 6 2017-06-01 74050205 7405049380 2615607826
## 7 2017 7 2017-07-01 70934300 7093457664 3113124827
## 8 2017 8 2017-08-01 69535451 6953572219 2995761408
## 9 2017 9 2017-09-01 136754090 13675462334 2536003054
## 10 2017 10 2017-10-01 92544327 9254468792 1956786021
## 11 2017 11 2017-11-01 156152999 15615360800 2094280651
## 12 2017 12 2017-12-01 292245699 29224683876 2570202596
## 13 2018 1 2018-01-01 256574528 25657552864 2394606529
## 14 2018 2 2018-02-01 225070744 22507162178 1995117494
## 15 2018 3 2018-03-01 216716670 21671751520 2132205702
## 16 2018 4 2018-04-01 126723543 12672403722 1787407410
## 17 2018 5 2018-05-01 99480004 9948039197 1884178568
## 18 2018 6 2018-06-01 77327887 7732818858 2317072842
## 19 2018 7 2018-07-01 70491825 7049209992 3076516808
## 20 2018 8 2018-08-01 73628195 7362848215 2666565449
## 21 2018 9 2018-09-01 76877874 7687817382 2226205087
## 22 2018 10 2018-10-01 91456098 9145645468 1922505661
## 23 2018 11 2018-11-01 183442904 18344361943 2126422448
## 24 2018 12 2018-12-01 274098326 27409939498 2544937320
## 25 2019 1 2019-01-01 272036368 27203742894 2405339756
## 26 2019 2 2019-02-01 295982749 29598390333 2236397294
## 27 2019 3 2019-03-01 210599369 21060019034 2050620632
## 28 2019 4 2019-04-01 115037539 11503798765 1788322259
## 29 2019 5 2019-05-01 111158190 11115862352 1815189861
## 30 2019 6 2019-06-01 75787863 7578815857 2418454504
## 31 2019 7 2019-07-01 73241548 7324183364 2726820259
## 32 2019 8 2019-08-01 70172439 7017271267 2876356186
## 33 2019 9 2019-09-01 73713782 7371406948 2285965349
## 34 2019 10 2019-10-01 109128238 10912866360 1818498345
## 35 2019 11 2019-11-01 188281565 18828229930 2075274460
## 36 2019 12 2019-12-01 270780478 27078153404 2545111200
## 37 2020 1 2020-01-01 297296398 29729755746 2435661356
## 38 2020 2 2020-02-01 213417355 21341818733 1919849451
## 39 2020 3 2020-03-01 210543362 21054418312 2093623179
## 40 2020 4 2020-04-01 147891631 14789220778 1946442584
## 41 2020 5 2020-05-01 98138323 9813870574 2181577771
## 42 2020 6 2020-06-01 80817601 8081791619 2537131639
## 43 2020 7 2020-07-01 80943142 8094345768 2926818249
## 44 2020 8 2020-08-01 76504327 7650462537 3339220306
## 45 2020 9 2020-09-01 77963575 7796387906 2712667506
## 46 2020 10 2020-10-01 97993457 9799383917 2328434857
## 47 2020 11 2020-11-01 218223203 21822405407 2283895788
## 48 2020 12 2020-12-01 302896475 30289765630 2740849821
## 49 2021 1 2021-01-01 297380109 29738126878 2583304201
## 50 2021 2 2021-02-01 223669318 22367019031 2046094821
## 51 2021 3 2021-03-01 227459191 22746007809 2078572237
## 52 2021 4 2021-04-01 133597441 13359796203 2073885444
## 53 2021 5 2021-05-01 102778274 10277867484 2364683776
## 54 2021 6 2021-06-01 78597892 7859819853 2882773155
## Residential_Electric_kBtu
## 1 9200909401
## 2 7129050870
## 3 6850869995
## 4 6271623496
## 5 7065078521
## 6 8924453902
## 7 10621981910
## 8 10221537924
## 9 8652842420
## 10 6676553904
## 11 7145685581
## 12 8769531258
## 13 8170397477
## 14 6807340890
## 15 7275085855
## 16 6098634083
## 17 6428817274
## 18 7905852537
## 19 10497075349
## 20 9098321312
## 21 7595811757
## 22 6559589315
## 23 7255353393
## 24 8683326136
## 25 8207019247
## 26 7630587567
## 27 6996717596
## 28 6101755548
## 29 6193427806
## 30 8251766768
## 31 9303910724
## 32 9814127307
## 33 7799713771
## 34 6204716353
## 35 7080836458
## 36 8683919414
## 37 8310476547
## 38 6550526327
## 39 7143442287
## 40 6641262097
## 41 7443543355
## 42 8656693152
## 43 9986303866
## 44 11393419684
## 45 9255621530
## 46 7944619732
## 47 7792652429
## 48 9351779589
## 49 8814233934
## 50 6981275529
## 51 7092088473
## 52 7076097135
## 53 8068301044
## 54 9836022005
Time window: from the first quarter of 2017 to the second quarter of 2021
Time window: from the first quarter of 2017 to the second quarter of 2021
## YEAR MONTH Time TOTALTHM Commercial_Gas_kBtu TOTALKWH
## 1 2017 1 2017-01-01 81974539 8197485870 2518133184
## 2 2017 2 2017-02-01 57175524 5717574698 2186409895
## 3 2017 3 2017-03-01 51732816 5173301776 2328765919
## 4 2017 4 2017-04-01 42328501 4232866608 2260528589
## 5 2017 5 2017-05-01 36825348 3682549162 2472760712
## 6 2017 6 2017-06-01 31689281 3168940459 2579187737
## 7 2017 7 2017-07-01 30972459 3097257979 2808792813
## 8 2017 8 2017-08-01 31294433 3129455505 2925396026
## 9 2017 9 2017-09-01 61404848 6140508748 2714269597
## 10 2017 10 2017-10-01 38024375 3802452330 2739510203
## 11 2017 11 2017-11-01 47704572 4770475805 2335565416
## 12 2017 12 2017-12-01 72381506 7238178829 2300499051
## 13 2018 1 2018-01-01 68229609 6822987510 2408160360
## 14 2018 2 2018-02-01 61167040 6116727855 2155263230
## 15 2018 3 2018-03-01 62150804 6215104639 2344730348
## 16 2018 4 2018-04-01 45152645 4515282110 2149231224
## 17 2018 5 2018-05-01 41023398 4102355799 2329429451
## 18 2018 6 2018-06-01 34280865 3428099870 2484527660
## 19 2018 7 2018-07-01 32624033 3262416023 2806919508
## 20 2018 8 2018-08-01 35658808 3565894707 2788621167
## 21 2018 9 2018-09-01 36552669 3655281156 2434135150
## 22 2018 10 2018-10-01 44246751 4424692356 2583642299
## 23 2018 11 2018-11-01 61713842 6171408268 2355850896
## 24 2018 12 2018-12-01 79774028 7977433912 2318696731
## 25 2019 1 2019-01-01 85968037 8596837228 2411412566
## 26 2019 2 2019-02-01 90504731 9050508397 2175465676
## 27 2019 3 2019-03-01 75080567 7508085981 2262687638
## 28 2019 4 2019-04-01 53456159 5345636748 2340405445
## 29 2019 5 2019-05-01 54414839 5441505122 2404667002
## 30 2019 6 2019-06-01 42491414 4249157972 2532843133
## 31 2019 7 2019-07-01 42441045 4244121052 2720967851
## 32 2019 8 2019-08-01 42087847 4208801114 2899824037
## 33 2019 9 2019-09-01 43114274 4311444215 2645042957
## 34 2019 10 2019-10-01 58230677 5823090410 2493295489
## 35 2019 11 2019-11-01 70930715 7093099163 2324287717
## 36 2019 12 2019-12-01 90107471 9010782242 2330850760
## 37 2020 1 2020-01-01 99682071 9968245976 2426397547
## 38 2020 2 2020-02-01 79910368 7991067965 2190511980
## 39 2020 3 2020-03-01 72628696 7262897925 2122420247
## 40 2020 4 2020-04-01 48329101 4832928948 1872348428
## 41 2020 5 2020-05-01 39984871 3998502694 2110068025
## 42 2020 6 2020-06-01 37347568 3734771366 2254418095
## 43 2020 7 2020-07-01 41091748 4109190826 2447583729
## 44 2020 8 2020-08-01 38181884 3818203291 2652700780
## 45 2020 9 2020-09-01 38699899 3870004993 2528382120
## 46 2020 10 2020-10-01 45482939 4548311638 2467052514
## 47 2020 11 2020-11-01 70066329 7006660226 1976895565
## 48 2020 12 2020-12-01 87891802 8789214478 2011384107
## 49 2021 1 2021-01-01 87849465 8784980761 2696911775
## 50 2021 2 2021-02-01 73948118 7394840640 2408987381
## 51 2021 3 2021-03-01 80053860 8005417221 2663954984
## 52 2021 4 2021-04-01 58823491 5882372041 2819988257
## 53 2021 5 2021-05-01 50407495 5040769159 3025457057
## 54 2021 6 2021-06-01 42960752 4296091955 3141496824
## Commercial_Electric_kBtu
## 1 8591870424
## 2 7460030562
## 3 7945749316
## 4 7712923546
## 5 8437059549
## 6 8800188559
## 7 9583601078
## 8 9981451241
## 9 9261087865
## 10 9347208813
## 11 7968949199
## 12 7849302762
## 13 8216643148
## 14 7353758141
## 15 8000219947
## 16 7333176936
## 17 7948013287
## 18 8477208376
## 19 9577209361
## 20 9514775422
## 21 8305269132
## 22 8815387524
## 23 8038163257
## 24 7911393246
## 25 8227739675
## 26 7422688887
## 27 7720290221
## 28 7985463378
## 29 8204723811
## 30 8642060770
## 31 9283942308
## 32 9894199614
## 33 9024886569
## 34 8507124208
## 35 7930469690
## 36 7952862793
## 37 8278868430
## 38 7474026876
## 39 7241697883
## 40 6388452836
## 41 7199552101
## 42 7692074540
## 43 8351155683
## 44 9051015061
## 45 8626839793
## 46 8417583178
## 47 6745167668
## 48 6862842573
## 49 9201862976
## 50 8219464944
## 51 9089414405
## 52 9621799933
## 53 10322859478
## 54 10718787163
## YEAR MONTH Time TOTALTHM.x Residential_Gas_kBtu TOTALKWH.x
## 1 2017 1 2017-01-01 332986863 33298816165 2696632298
## 2 2017 2 2017-02-01 214756795 21475763255 2089405296
## 3 2017 3 2017-03-01 167698331 16769898502 2007875145
## 4 2017 4 2017-04-01 128910844 12891134675 1838107707
## 5 2017 5 2017-05-01 93587412 9358777699 2070656073
## 6 2017 6 2017-06-01 74050205 7405049380 2615607826
## 7 2017 7 2017-07-01 70934300 7093457664 3113124827
## 8 2017 8 2017-08-01 69535451 6953572219 2995761408
## 9 2017 9 2017-09-01 136754090 13675462334 2536003054
## 10 2017 10 2017-10-01 92544327 9254468792 1956786021
## 11 2017 11 2017-11-01 156152999 15615360800 2094280651
## 12 2017 12 2017-12-01 292245699 29224683876 2570202596
## 13 2018 1 2018-01-01 256574528 25657552864 2394606529
## 14 2018 2 2018-02-01 225070744 22507162178 1995117494
## 15 2018 3 2018-03-01 216716670 21671751520 2132205702
## 16 2018 4 2018-04-01 126723543 12672403722 1787407410
## 17 2018 5 2018-05-01 99480004 9948039197 1884178568
## 18 2018 6 2018-06-01 77327887 7732818858 2317072842
## 19 2018 7 2018-07-01 70491825 7049209992 3076516808
## 20 2018 8 2018-08-01 73628195 7362848215 2666565449
## 21 2018 9 2018-09-01 76877874 7687817382 2226205087
## 22 2018 10 2018-10-01 91456098 9145645468 1922505661
## 23 2018 11 2018-11-01 183442904 18344361943 2126422448
## 24 2018 12 2018-12-01 274098326 27409939498 2544937320
## 25 2019 1 2019-01-01 272036368 27203742894 2405339756
## 26 2019 2 2019-02-01 295982749 29598390333 2236397294
## 27 2019 3 2019-03-01 210599369 21060019034 2050620632
## 28 2019 4 2019-04-01 115037539 11503798765 1788322259
## 29 2019 5 2019-05-01 111158190 11115862352 1815189861
## 30 2019 6 2019-06-01 75787863 7578815857 2418454504
## 31 2019 7 2019-07-01 73241548 7324183364 2726820259
## 32 2019 8 2019-08-01 70172439 7017271267 2876356186
## 33 2019 9 2019-09-01 73713782 7371406948 2285965349
## 34 2019 10 2019-10-01 109128238 10912866360 1818498345
## 35 2019 11 2019-11-01 188281565 18828229930 2075274460
## 36 2019 12 2019-12-01 270780478 27078153404 2545111200
## 37 2020 1 2020-01-01 297296398 29729755746 2435661356
## 38 2020 2 2020-02-01 213417355 21341818733 1919849451
## 39 2020 3 2020-03-01 210543362 21054418312 2093623179
## 40 2020 4 2020-04-01 147891631 14789220778 1946442584
## 41 2020 5 2020-05-01 98138323 9813870574 2181577771
## 42 2020 6 2020-06-01 80817601 8081791619 2537131639
## 43 2020 7 2020-07-01 80943142 8094345768 2926818249
## 44 2020 8 2020-08-01 76504327 7650462537 3339220306
## 45 2020 9 2020-09-01 77963575 7796387906 2712667506
## 46 2020 10 2020-10-01 97993457 9799383917 2328434857
## 47 2020 11 2020-11-01 218223203 21822405407 2283895788
## 48 2020 12 2020-12-01 302896475 30289765630 2740849821
## 49 2021 1 2021-01-01 297380109 29738126878 2583304201
## 50 2021 2 2021-02-01 223669318 22367019031 2046094821
## 51 2021 3 2021-03-01 227459191 22746007809 2078572237
## 52 2021 4 2021-04-01 133597441 13359796203 2073885444
## 53 2021 5 2021-05-01 102778274 10277867484 2364683776
## 54 2021 6 2021-06-01 78597892 7859819853 2882773155
## Residential_Electric_kBtu TOTALTHM.y Commercial_Gas_kBtu TOTALKWH.y
## 1 9200909401 81974539 8197485870 2518133184
## 2 7129050870 57175524 5717574698 2186409895
## 3 6850869995 51732816 5173301776 2328765919
## 4 6271623496 42328501 4232866608 2260528589
## 5 7065078521 36825348 3682549162 2472760712
## 6 8924453902 31689281 3168940459 2579187737
## 7 10621981910 30972459 3097257979 2808792813
## 8 10221537924 31294433 3129455505 2925396026
## 9 8652842420 61404848 6140508748 2714269597
## 10 6676553904 38024375 3802452330 2739510203
## 11 7145685581 47704572 4770475805 2335565416
## 12 8769531258 72381506 7238178829 2300499051
## 13 8170397477 68229609 6822987510 2408160360
## 14 6807340890 61167040 6116727855 2155263230
## 15 7275085855 62150804 6215104639 2344730348
## 16 6098634083 45152645 4515282110 2149231224
## 17 6428817274 41023398 4102355799 2329429451
## 18 7905852537 34280865 3428099870 2484527660
## 19 10497075349 32624033 3262416023 2806919508
## 20 9098321312 35658808 3565894707 2788621167
## 21 7595811757 36552669 3655281156 2434135150
## 22 6559589315 44246751 4424692356 2583642299
## 23 7255353393 61713842 6171408268 2355850896
## 24 8683326136 79774028 7977433912 2318696731
## 25 8207019247 85968037 8596837228 2411412566
## 26 7630587567 90504731 9050508397 2175465676
## 27 6996717596 75080567 7508085981 2262687638
## 28 6101755548 53456159 5345636748 2340405445
## 29 6193427806 54414839 5441505122 2404667002
## 30 8251766768 42491414 4249157972 2532843133
## 31 9303910724 42441045 4244121052 2720967851
## 32 9814127307 42087847 4208801114 2899824037
## 33 7799713771 43114274 4311444215 2645042957
## 34 6204716353 58230677 5823090410 2493295489
## 35 7080836458 70930715 7093099163 2324287717
## 36 8683919414 90107471 9010782242 2330850760
## 37 8310476547 99682071 9968245976 2426397547
## 38 6550526327 79910368 7991067965 2190511980
## 39 7143442287 72628696 7262897925 2122420247
## 40 6641262097 48329101 4832928948 1872348428
## 41 7443543355 39984871 3998502694 2110068025
## 42 8656693152 37347568 3734771366 2254418095
## 43 9986303866 41091748 4109190826 2447583729
## 44 11393419684 38181884 3818203291 2652700780
## 45 9255621530 38699899 3870004993 2528382120
## 46 7944619732 45482939 4548311638 2467052514
## 47 7792652429 70066329 7006660226 1976895565
## 48 9351779589 87891802 8789214478 2011384107
## 49 8814233934 87849465 8784980761 2696911775
## 50 6981275529 73948118 7394840640 2408987381
## 51 7092088473 80053860 8005417221 2663954984
## 52 7076097135 58823491 5882372041 2819988257
## 53 8068301044 50407495 5040769159 3025457057
## 54 9836022005 42960752 4296091955 3141496824
## Commercial_Electric_kBtu
## 1 8591870424
## 2 7460030562
## 3 7945749316
## 4 7712923546
## 5 8437059549
## 6 8800188559
## 7 9583601078
## 8 9981451241
## 9 9261087865
## 10 9347208813
## 11 7968949199
## 12 7849302762
## 13 8216643148
## 14 7353758141
## 15 8000219947
## 16 7333176936
## 17 7948013287
## 18 8477208376
## 19 9577209361
## 20 9514775422
## 21 8305269132
## 22 8815387524
## 23 8038163257
## 24 7911393246
## 25 8227739675
## 26 7422688887
## 27 7720290221
## 28 7985463378
## 29 8204723811
## 30 8642060770
## 31 9283942308
## 32 9894199614
## 33 9024886569
## 34 8507124208
## 35 7930469690
## 36 7952862793
## 37 8278868430
## 38 7474026876
## 39 7241697883
## 40 6388452836
## 41 7199552101
## 42 7692074540
## 43 8351155683
## 44 9051015061
## 45 8626839793
## 46 8417583178
## 47 6745167668
## 48 6862842573
## 49 9201862976
## 50 8219464944
## 51 9089414405
## 52 9621799933
## 53 10322859478
## 54 10718787163
*The World Health Organization (WHO) declared a Public Health Emergency of International Concern on 30 January 2020, and a pandemic on 11 March 2020.
2.2 Comment on observable changes in energy consumption that may be attributable to the COVID-19 pandemic
In the chart “Ratio of commercial to residential energy consumption”, I used the red line to mark the time when WHO declared a pandemic (according to WHO). It can be seen that after this time point, the ratio of commercial energy consumption to residential energy consumption has dropped significantly. This is in line with our perception that due to the epidemic, people spend more time at home instead of in commercial buildings.
Starting from the first quarter of 2021, the ratio of commercial energy consumption to residential energy consumption has rebounded significantly. This may be due to the liberalization of restrictions on the COVID-19 in various regions. The implementation of the epidemic control policy is no longer that mandatory. More people choose to return to commercial buildings. As of the second quarter of 2021, this ratio is basically the same as the second quarter of 2019. Compared with the same period before the pandemic, there was even a slight improvement.
According to the chart “total gas consumption - residential and commercial”, since the first quarter of 2017, the gas consumption of commercial and residential buildings has been showing a downward trend. However, after the outbreak of the epidemic, this downward trend no longer continued, and the total gas consumption increased.
According to the chart “total electricity consumption - residential and commercial”, since the outbreak of the epidemic, total electricity consumption has risen significantly. This may be due to the significant increase in the amount of time people spend indoors during the epidemic, and the decrease in outdoor activities, leading to an increase in electricity consumption. Starting from the first quarter of 2021, such high-level electricity consumption has dropped again. This may be because the impact of the epidemic on people’s normal lives has been significantly reduced, and the total electricity consumption has basically fallen to the level before the epidemic.